UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lORnr32tHCY8KnQ6b7got+7Gb/TWwSu/bqEdlKBXcoI='
WHERE
key_id = 'c4575184c4c651d0643c433392b468954cab79b40e3df2e96522e9f62282e82f'
AND (
token = 'lORnr32tHCY8KnQ6b7got+7Gb/TWwSu/bqEdlKBXcoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)