UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6dEjGjYqIgXjto59AednbThm7PmIeJMH4SAhUIySYQE='
WHERE
key_id = '96a78da231e0bbf5d625751a2acf32436d78f93f8f997efbd3c3d68c7bdcccda'
AND (
token = '6dEjGjYqIgXjto59AednbThm7PmIeJMH4SAhUIySYQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)