UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GGYG7EzUSXV/02mNzs683zOVE2kUvQnsjb4ds66SmGQ='
WHERE
key_id = '118a164433821afce8b92a97058f8c022e8a36247efb4d8683d9e99570c788ee'
AND (
token = 'GGYG7EzUSXV/02mNzs683zOVE2kUvQnsjb4ds66SmGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)