UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W97I4gdXDhnWxirtXlFLbz3yykwgF9NlX25MryOlI6M='
WHERE
key_id = '56796ea8295f3a58694a0add24cfd420b5e2ee5ebb14320a15e81b6866985635'
AND (
token = 'W97I4gdXDhnWxirtXlFLbz3yykwgF9NlX25MryOlI6M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)