UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6v+UBrPqnF9dL92C2z8izE2F9TR8CldiJTnyzmMmUA='
WHERE
key_id = 'c420d228c518a37bf85c187dfbab8ed8f8a7df07cfced53da740158667d6a8ec'
AND (
token = 'o6v+UBrPqnF9dL92C2z8izE2F9TR8CldiJTnyzmMmUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)