UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6sAfQZKXjtiMs4n8XopD9RD1YYILqLApWWnuFnl4Ams='
WHERE
key_id = '34aec413fec44c674f85d2ac89dfad441fc4cccdca59a9913f96be9717e07a2e'
AND (
token = '6sAfQZKXjtiMs4n8XopD9RD1YYILqLApWWnuFnl4Ams='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)