UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YbJdI7froYqfRQdsAFFiKtIb8EeQhfdk5q6/iIk/yLQ='
WHERE
key_id = '03f24ed5d74d5f973140eefe4c37154b5ac2720918c316b3efdce856d016800c'
AND (
token = 'YbJdI7froYqfRQdsAFFiKtIb8EeQhfdk5q6/iIk/yLQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)