UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FjP5eMXjxkkFxKjsfpafuTrcgShhKLH66OrswU+yazM='
WHERE
key_id = 'f54fc69b798a50b78b5ebe6e545ce43812be3645623cf7a35b40701bb731c149'
AND (
token = 'FjP5eMXjxkkFxKjsfpafuTrcgShhKLH66OrswU+yazM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)