UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKdPsp6sE3ayfincQzMB0susVctWqJIbmKZSa3Y9kPw='
WHERE
key_id = '9b40e1fbe2d88e682496cb92f36c81626addea9eb4e94286cefea31ad2ff2aaf'
AND (
token = 'LKdPsp6sE3ayfincQzMB0susVctWqJIbmKZSa3Y9kPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)