UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DG4E1BHZMkJiotKU3GaYfZRwZikRBYRbU6j01WE2mkM='
WHERE
key_id = '4d189c3fe720b7e336cce4f8af9712cfb43fe5d0d2bed025aa674d5c57190861'
AND (
token = 'DG4E1BHZMkJiotKU3GaYfZRwZikRBYRbU6j01WE2mkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)