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