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