UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HH1F1LhvJ8HLmCpj2ncHDeSrV/90H+JOG+0J93IJ7I8='
WHERE
key_id = 'a4cba35c3dde53f91c070d9340163eb996f1e6ba3de08dc90830152490281729'
AND (
token = 'HH1F1LhvJ8HLmCpj2ncHDeSrV/90H+JOG+0J93IJ7I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)