UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N0NxBs0UhvIoCw1DbWLav1aeWTAWJCYi4tcFUSByyUA='
WHERE
key_id = '47f821319e3fa8cf147987785b5489bf38b026a9819259910fafb79ec4cb4d8c'
AND (
token = 'N0NxBs0UhvIoCw1DbWLav1aeWTAWJCYi4tcFUSByyUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)