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