UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qsg0eQ/LnQqIjsyJbxSmnXfXmrX1qHXUK0tHOBNbPCg='
WHERE
key_id = '1a40af99a80fe98f48ee4bb988610d2faea3c4216c64a8660ca18df8d3340f92'
AND (
token = 'Qsg0eQ/LnQqIjsyJbxSmnXfXmrX1qHXUK0tHOBNbPCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)