UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKfcx/m1M3h4ISNzWdq5PecPpWcVAFINaILvAlyRngA='
WHERE
key_id = 'f4ac0c3288ae372acf4a472c86f40cb091ad867d206a25d215f5e3ca900d148a'
AND (
token = 'DKfcx/m1M3h4ISNzWdq5PecPpWcVAFINaILvAlyRngA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)