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