UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ltMHs1OYoSX2Pq4YYIN+htO6OvOzH7NwX2TcHfa3xV8='
WHERE
key_id = '47ac538f0c4316d3bbd7e95550fa2133a644377a12edd0d5c1584d1ba1a933ac'
AND (
token = 'ltMHs1OYoSX2Pq4YYIN+htO6OvOzH7NwX2TcHfa3xV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)