UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RZ5DjQ39HMzdUvhpH5DgZ20OJl+aq5i6BzXBjVLZytU='
WHERE
key_id = 'e4227c08de4f214ea93bb687878a37c02629911a0825d1521357f977a70d143f'
AND (
token = 'RZ5DjQ39HMzdUvhpH5DgZ20OJl+aq5i6BzXBjVLZytU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)