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