UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiH4jQDZCkXai1gWidPNJK58OSbslPs4tUdxkw1OQRM='
WHERE
key_id = 'c690a4b165aaaebb82d62f3c6a1038a2769fb3ba348e7168b17413fc68214fba'
AND (
token = 'GiH4jQDZCkXai1gWidPNJK58OSbslPs4tUdxkw1OQRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)