UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/lZcCw+LxtlhZ+22Vt88EJPWUcc87jPMwKMT9OkFPjc='
WHERE
key_id = 'c5a31d10698509521ef871878d3943d32642249a45a9813f42cef5781b968f11'
AND (
token = '/lZcCw+LxtlhZ+22Vt88EJPWUcc87jPMwKMT9OkFPjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)