UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sn1agizGTDlbc7rIzLhj282YBpERU807dHlSYN/fnmc='
WHERE
key_id = 'b1d7b3d6f60e9aee4e253836ee169645d09ad02ac7018ae3f06c49a714ef63cd'
AND (
token = 'sn1agizGTDlbc7rIzLhj282YBpERU807dHlSYN/fnmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)