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