UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zVHRS5wkcrALmXuLlUniazPqmZDxjqM1axaJICMVUk='
WHERE
key_id = 'bfe53d69bcc1c0602f7e860196ee9dd70d8bd6592b8f7b93d2804dfe78993449'
AND (
token = '9zVHRS5wkcrALmXuLlUniazPqmZDxjqM1axaJICMVUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)