UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKw52Lchx9DcVM5+5MrFfG5MDxvooDKqRlxi59g6fw8='
WHERE
key_id = 'fd5c1e264506cf45c6cd17eb367d7ca792ca062a5e5447b79f303fb04a2aa7d5'
AND (
token = 'pKw52Lchx9DcVM5+5MrFfG5MDxvooDKqRlxi59g6fw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)