UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkiq7q7NUwh7ToG7I/qNnKGV6sFW54i20TVjwi8qsok='
WHERE
key_id = '65460693b598ee565a0e4d772d85ae164a59210c396548e71161d4c234a6fa52'
AND (
token = 'pkiq7q7NUwh7ToG7I/qNnKGV6sFW54i20TVjwi8qsok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)