UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hL+htbeCVEbi8gXV5rMl51IrS2yc+xg9WGuEg/YJko4='
WHERE
key_id = 'c63940d60b3a8703fe677071de2a3daab4eb2b06280cc353d00dae39388f7adf'
AND (
token = 'hL+htbeCVEbi8gXV5rMl51IrS2yc+xg9WGuEg/YJko4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)