UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnsrqwQc4Uu65brbLSp+XIg+mkA5G/hPQcaE7lG+YBs='
WHERE
key_id = 'ff3ae89cc8c58273c2627144f93107d08be049187a29c9b0892ef94bc995ef70'
AND (
token = 'XnsrqwQc4Uu65brbLSp+XIg+mkA5G/hPQcaE7lG+YBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)