UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V1xLexPlhSpWe+9eXlF2N48juwpdX9oqOSlM4HcBwPU='
WHERE
key_id = '6746d15cd040c04795df6efaf70391060dfac68e5c73871d5ff19eb819cd165d'
AND (
token = 'V1xLexPlhSpWe+9eXlF2N48juwpdX9oqOSlM4HcBwPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)