UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPDW4NzPyfHxyGdqdfdjGNWx4u3U+jduSB5tzGm8AiI='
WHERE
key_id = '947197ae705bab9c16c7a8cd2ee267c6f8128eaeff6d830e08a6d841da3d2723'
AND (
token = 'nPDW4NzPyfHxyGdqdfdjGNWx4u3U+jduSB5tzGm8AiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)