UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GQ4gC1fPmVzzC0J0otPk5emncWFnkQLRPLUyFbmyzeQ='
WHERE
key_id = 'e178d46f9798c039095461e180128d559100f1dfc5bd7c4d9c9f99b923922682'
AND (
token = 'GQ4gC1fPmVzzC0J0otPk5emncWFnkQLRPLUyFbmyzeQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)