UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsyxZTDWG3Ke3gcVt3cHhaX8a9WK6mI6UtWL6TOYOm0='
WHERE
key_id = '6369728e2d27e8221e08c7bdeaa823acfb152f0599086664102b909c5c67b859'
AND (
token = 'ZsyxZTDWG3Ke3gcVt3cHhaX8a9WK6mI6UtWL6TOYOm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)