UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDU8LbyaDOcso/yb+YI7SOfp9mC/UKauY3jqf0vaPM8='
WHERE
key_id = '8f2df7428890cc624d8755932e5350ba72b85ddbd8070eb5728538cedf1fde8f'
AND (
token = 'zDU8LbyaDOcso/yb+YI7SOfp9mC/UKauY3jqf0vaPM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)