UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mia7bCX5VYdyyA9zPoi8newvh6npM2TNhFhADgDWmYM='
WHERE
key_id = '39cbd1298574dc1e5a958173be755062147264866e01e527edf1fae7dcbcb1bd'
AND (
token = 'mia7bCX5VYdyyA9zPoi8newvh6npM2TNhFhADgDWmYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)