UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qHMN3xpQUl0ih1fH/ZtRn7wIWEjiadwgOhddEfKWkyw='
WHERE
key_id = 'f17507562c8aa578c9d67aafcea45795b6be62a6567622760edf135dc0a387b9'
AND (
token = 'qHMN3xpQUl0ih1fH/ZtRn7wIWEjiadwgOhddEfKWkyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)