UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WTkyYM7g3sUL3lp7AAJaz+jmifoCBH4vpg7wHXDeVCg='
WHERE
key_id = '6ef1731608ea3a249ee469f22629ebdbfcc1abda10d470dacd7593d4c59b3d6c'
AND (
token = 'WTkyYM7g3sUL3lp7AAJaz+jmifoCBH4vpg7wHXDeVCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)