UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qroZ4k91rjqdsN8lpY7f81rNg3vuUBqRJTGIGtKqCN0='
WHERE
key_id = 'f14009da0e34abd88e58427fa93f1f8412acc4c82df49259ecf37bfed80494e3'
AND (
token = 'qroZ4k91rjqdsN8lpY7f81rNg3vuUBqRJTGIGtKqCN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)