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