UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dmps4lVrxnnpf7IYK1p70aeTVE34MCF1x1+zL47+xl0='
WHERE
key_id = '3cc28f3dfb347364a6450384e9226aae9bb8ead1cbd26fc27ae9c75c13b627fb'
AND (
token = 'dmps4lVrxnnpf7IYK1p70aeTVE34MCF1x1+zL47+xl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)