UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnLP6+8yvBYWwy5BXKN3al0jFV7J7JmqPpjigDjm0qA='
WHERE
key_id = 'bd08fed0e88821460140959e6860fd760d35204fd1d6328e2a768198ec9f99f3'
AND (
token = 'QnLP6+8yvBYWwy5BXKN3al0jFV7J7JmqPpjigDjm0qA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)